insert overwrite table jms_dim.dim_mysql_lmdm_sys_network
select
id
,name
,code
,signature_code
,cn_name
,en_name
,country_id
,country_code
,country_desc
,country_three_code
,regional_id
,regional_desc
,area_info_id
,area_info_desc
,provider_id
,provider_desc
,city_id
,city_desc
,area_id
,area_desc
,township_id
,principal
,mobile
,telephone
,parent_network_id
,parent_network_code
,parent_network_name
,financial_center_id
,financial_center_code
,financial_center_desc
,function_type_id
,function_type_desc
,type_id
,type_desc
,institutional_level_id
,institutional_level_desc
,max_collection_money
,settlement_destination_id
,settlement_destination_desc
,is_collection_identifier
,is_distribution_center
,business_model_id
,business_model_desc
,local_currency_id
,local_currency_code
,local_currency_desc
,is_financial_center
,is_waybill_identification
,is_to_payment
,is_visibility
,is_enable
,is_leaf
,is_delete
,address
,business_principal
,business_telephone
,customer_service_principal
,customer_service_telephone
,longitude
,latitude
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
,remark
,path
,is_receiving
,is_dispatch
,zip_code
,start_business_time
,end_business_time
,last_update_time_sync
,coordinate
,subordinate_agent
,is_first_network_settle
,simple_name
,is_first_franchisee
,is_second_franchisee
,is_entrepot
,to_payment_limit
,opening_type
,opening_time
,is_retrogression
,is_suspend
,leaving_time
from jms_ods.yl_cn_mysql_lmdm_sys_network where dt = '{{ execution_date | cst_ds_nodash }}'
 distribute by 1 ;